-- INSERT INTO dbo.t_ReleaseObjects( Parent, Scope)VALUES( 1, 'G')
-- p_InsRepoObj "S",123,"admin",0,"JAN","PMO","PMO","PMO","ADMIN","ADMIN","ADMIN","PM","O","PMO","12-12-2010","NA"
-- p_InsRepoObj "M",123,"admin",0,"JAN","PMO","PMO","SvnPath","PMO","ADMIN","ADMIN","ADMIN","PM","O","PMO","12-12-2010","NA"
use common
go
IF OBJECT_ID('dbo.p_InsRepoObj') IS NOT NULL
BEGIN
    DROP PROCEDURE dbo.p_InsRepoObj
    IF OBJECT_ID('dbo.p_InsRepoObj') IS NOT NULL
        PRINT '<<< FAILED DROPPING PROCEDURE dbo.p_InsRepoObj >>>'
    ELSE
        PRINT '<<< DROPPED PROCEDURE dbo.p_InsRepoObj >>>'
END
go
create proc p_InsRepoObj
(
	@RepoName			varchar(30),	-- @DBName
	@Hostname			varchar(250),	
	@LoginName			varchar(30),	--  
	@Pass				varchar(30)	-- 
) as
begin
     
			insert into t_Repo 
			( RepoName, Hostname,LoginName,Pass
			)
			values
			(@RepoName, @Hostname,@LoginName,@Pass)
	return 0 
End

go
EXEC sp_procxmode 'dbo.p_InsRepoObj','unchained'
go
IF OBJECT_ID('dbo.p_InsRepoObj') IS NOT NULL
    PRINT '<<< CREATED PROCEDURE dbo.p_InsRepoObj >>>'
ELSE
    PRINT '<<< FAILED CREATING PROCEDURE dbo.p_InsRepoObj >>>'
go
GRANT EXECUTE ON dbo.p_InsRepoObj TO public
go